Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 608677 |
| Missing cells | 1435082 |
| Missing cells (%) | 9.4% |
| Duplicate rows | 1703 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 116.1 MiB |
| Average record size in memory | 200.0 B |
Variable types
| DateTime | 3 |
|---|---|
| Numeric | 17 |
| Categorical | 5 |
Gamma Measured while Drilling has constant value "0.0" | Constant |
H2S 01 has constant value "0.0" | Constant |
| Dataset has 1703 (0.3%) duplicate rows | Duplicates |
Azimuth is highly overall correlated with Inclination | High correlation |
Bit Diameter is highly overall correlated with Hookload and 1 other fields | High correlation |
Bit Revolutions per Minute is highly overall correlated with Differential Pressure and 10 other fields | High correlation |
Block Position is highly overall correlated with Rig Mode | High correlation |
Depth Hole Total Vertical Depth is highly overall correlated with Inclination | High correlation |
Differential Pressure is highly overall correlated with Bit Revolutions per Minute and 5 other fields | High correlation |
Downhole Torque is highly overall correlated with Bit Revolutions per Minute and 6 other fields | High correlation |
Flow In is highly overall correlated with Bit Revolutions per Minute and 9 other fields | High correlation |
Hookload is highly overall correlated with Bit Diameter and 6 other fields | High correlation |
Inclination is highly overall correlated with Azimuth and 1 other fields | High correlation |
Mud Temperature is highly overall correlated with Bit Revolutions per Minute and 8 other fields | High correlation |
On Bottom is highly overall correlated with Mud Temperature and 4 other fields | High correlation |
Pump Pressure is highly overall correlated with Bit Revolutions per Minute and 9 other fields | High correlation |
Return Flow is highly overall correlated with Bit Revolutions per Minute and 4 other fields | High correlation |
Rig Mode is highly overall correlated with Bit Revolutions per Minute and 4 other fields | High correlation |
Top Drive Revolutions per Minute is highly overall correlated with Bit Revolutions per Minute and 5 other fields | High correlation |
Top Drive Torque is highly overall correlated with Bit Revolutions per Minute and 8 other fields | High correlation |
Total Strokes per Minute is highly overall correlated with Bit Revolutions per Minute and 9 other fields | High correlation |
Weight on Bit is highly overall correlated with Bit Diameter and 2 other fields | High correlation |
Bit Diameter is highly imbalanced (59.8%) | Imbalance |
Azimuth has 52962 (8.7%) missing values | Missing |
Bit Diameter has 74927 (12.3%) missing values | Missing |
Bit Revolutions per Minute has 83712 (13.8%) missing values | Missing |
Block Position has 11827 (1.9%) missing values | Missing |
Depth Hole Total Vertical Depth has 11251 (1.8%) missing values | Missing |
Differential Pressure has 11814 (1.9%) missing values | Missing |
Downhole Torque has 103996 (17.1%) missing values | Missing |
Gamma Measured while Drilling has 524744 (86.2%) missing values | Missing |
H2S 01 has 311427 (51.2%) missing values | Missing |
Hookload has 11837 (1.9%) missing values | Missing |
Inclination has 52957 (8.7%) missing values | Missing |
Mud Temperature has 11173 (1.8%) missing values | Missing |
On Bottom has 11813 (1.9%) missing values | Missing |
Pump Pressure has 11811 (1.9%) missing values | Missing |
Rate of Penetration (Depth/Hour) has 11813 (1.9%) missing values | Missing |
Return Flow has 11816 (1.9%) missing values | Missing |
Rig Mode has 87404 (14.4%) missing values | Missing |
Top Drive Revolutions per Minute has 11816 (1.9%) missing values | Missing |
Top Drive Torque has 11816 (1.9%) missing values | Missing |
Weight on Bit has 11813 (1.9%) missing values | Missing |
Bit Revolutions per Minute is highly skewed (γ1 = 170.2318309) | Skewed |
Flow In is highly skewed (γ1 = 32.00149324) | Skewed |
Hookload is highly skewed (γ1 = 37.1113781) | Skewed |
Rate of Penetration (Depth/Hour) is highly skewed (γ1 = 200.743463) | Skewed |
Total Strokes per Minute is highly skewed (γ1 = 32.00098636) | Skewed |
Weight on Bit is highly skewed (γ1 = -32.40599563) | Skewed |
Azimuth has 146253 (24.0%) zeros | Zeros |
Bit Revolutions per Minute has 6811 (1.1%) zeros | Zeros |
Flow In has 284244 (46.7%) zeros | Zeros |
Inclination has 146253 (24.0%) zeros | Zeros |
Pump Pressure has 95931 (15.8%) zeros | Zeros |
Rate of Penetration (Depth/Hour) has 526321 (86.5%) zeros | Zeros |
Return Flow has 58396 (9.6%) zeros | Zeros |
Top Drive Revolutions per Minute has 20125 (3.3%) zeros | Zeros |
Top Drive Torque has 405112 (66.6%) zeros | Zeros |
Total Strokes per Minute has 284244 (46.7%) zeros | Zeros |
Weight on Bit has 7148 (1.2%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-17 12:24:17.866090 |
|---|---|
| Analysis finished | 2025-03-17 12:26:09.081007 |
| Duration | 1 minute and 51.21 seconds |
| Software version | ydata-profiling vv4.14.0 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 102900 |
|---|---|
| Distinct (%) | 16.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 4.6 MiB |
| Minimum | 2020-10-25 12:38:00 |
|---|---|
| Maximum | 2021-01-05 11:01:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Date (Date Only)
Date
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 4.6 MiB |
| Minimum | 2020-10-25 00:00:00 |
|---|---|
| Maximum | 2021-01-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Date (Time Only)
Date
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 4.6 MiB |
| Minimum | 2025-03-17 00:00:00 |
|---|---|
| Maximum | 2025-03-17 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Azimuth
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 312 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 52962 |
| Missing (%) | 8.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 82.81647 |
| Minimum | 0 |
|---|---|
| Maximum | 358.06 |
| Zeros | 146253 |
| Zeros (%) | 24.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 103.44 |
| Q3 | 110.04 |
| 95-th percentile | 219.54 |
| Maximum | 358.06 |
| Range | 358.06 |
| Interquartile range (IQR) | 110.04 |
Descriptive statistics
| Standard deviation | 65.388791 |
|---|---|
| Coefficient of variation (CV) | 0.78956264 |
| Kurtosis | 1.6655609 |
| Mean | 82.81647 |
| Median Absolute Deviation (MAD) | 7.31 |
| Skewness | 0.75041627 |
| Sum | 46022355 |
| Variance | 4275.694 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 146253 | |
| 103.44 | 89178 | |
| 110.04 | 40667 | 6.7% |
| 36.29 | 29843 | 4.9% |
| 110.53 | 23438 | 3.9% |
| 110.46 | 20876 | 3.4% |
| 109.68 | 17480 | 2.9% |
| 219.54 | 12879 | 2.1% |
| 108.05 | 11342 | 1.9% |
| 106.22 | 10332 | 1.7% |
| Other values (302) | 153427 | |
| (Missing) | 52962 | 8.7% |
| Value | Count | Frequency (%) |
| 0 | 146253 | |
| 4.38 | 501 | 0.1% |
| 6.61 | 243 | < 0.1% |
| 6.67 | 1076 | 0.2% |
| 6.76 | 8 | < 0.1% |
| 12.11 | 61 | < 0.1% |
| 13.79 | 267 | < 0.1% |
| 13.88 | 7 | < 0.1% |
| 14.78 | 379 | 0.1% |
| 15.46 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 358.06 | 911 | |
| 349 | 272 | < 0.1% |
| 337.05 | 116 | < 0.1% |
| 335.91 | 200 | < 0.1% |
| 335.82 | 9 | < 0.1% |
| 334.41 | 1061 | |
| 332.83 | 777 | |
| 315.43 | 1492 | |
| 315.25 | 251 | < 0.1% |
| 310.42 | 574 | 0.1% |
Bit Diameter
Categorical
High correlation Imbalance Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 74927 |
| Missing (%) | 12.3% |
| Memory size | 31.0 MiB |
| 8.75 | |
|---|---|
| 12.0 | |
| 12.25 | 832 |
| 1.0 | 29 |
| 0.0 | 10 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.0014857 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 8.75 | 355394 | |
| 12.0 | 177485 | |
| 12.25 | 832 | 0.1% |
| 1.0 | 29 | < 0.1% |
| 0.0 | 10 | < 0.1% |
| (Missing) | 74927 | 12.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 8.75 | 355394 | |
| 12.0 | 177485 | |
| 12.25 | 832 | 0.2% |
| 1.0 | 29 | < 0.1% |
| 0.0 | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 533750 | |
| 5 | 356226 | |
| 8 | 355394 | |
| 7 | 355394 | |
| 2 | 179149 | 8.4% |
| 1 | 178346 | 8.4% |
| 0 | 177534 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2135793 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 533750 | |
| 5 | 356226 | |
| 8 | 355394 | |
| 7 | 355394 | |
| 2 | 179149 | 8.4% |
| 1 | 178346 | 8.4% |
| 0 | 177534 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2135793 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 533750 | |
| 5 | 356226 | |
| 8 | 355394 | |
| 7 | 355394 | |
| 2 | 179149 | 8.4% |
| 1 | 178346 | 8.4% |
| 0 | 177534 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2135793 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 533750 | |
| 5 | 356226 | |
| 8 | 355394 | |
| 7 | 355394 | |
| 2 | 179149 | 8.4% |
| 1 | 178346 | 8.4% |
| 0 | 177534 | 8.3% |
Bit Revolutions per Minute
Real number (ℝ)
High correlation Missing Skewed Zeros
| Distinct | 220472 |
|---|---|
| Distinct (%) | 42.0% |
| Missing | 83712 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.353336 |
| Minimum | 0 |
|---|---|
| Maximum | 377404.16 |
| Zeros | 6811 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0703 |
| Q1 | 0.25144 |
| median | 16.458 |
| Q3 | 145.51305 |
| 95-th percentile | 211.26201 |
| Maximum | 377404.16 |
| Range | 377404.16 |
| Interquartile range (IQR) | 145.26161 |
Descriptive statistics
| Standard deviation | 1614.4088 |
|---|---|
| Coefficient of variation (CV) | 16.414378 |
| Kurtosis | 34983.343 |
| Mean | 98.353336 |
| Median Absolute Deviation (MAD) | 16.36758 |
| Skewness | 170.23183 |
| Sum | 51632059 |
| Variance | 2606315.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.21118 | 13285 | 2.2% |
| 0.19106 | 13144 | 2.2% |
| 0.17093 | 12840 | 2.1% |
| 0.23131 | 12807 | 2.1% |
| 0.25144 | 12642 | 2.1% |
| 0.27156 | 11977 | 2.0% |
| 0.1508 | 11818 | 1.9% |
| 0.29169 | 11396 | 1.9% |
| 0.13068 | 10772 | 1.8% |
| 0.31182 | 10339 | 1.7% |
| Other values (220462) | 403945 | |
| (Missing) | 83712 | 13.8% |
| Value | Count | Frequency (%) |
| 0 | 6811 | |
| 0.00992 | 3020 | 0.5% |
| 0.03004 | 4257 | 0.7% |
| 0.05017 | 5499 | |
| 0.0703 | 6943 | |
| 0.09042 | 8237 | |
| 0.11055 | 9706 | |
| 0.13068 | 10772 | |
| 0.1508 | 11818 | |
| 0.17093 | 12840 |
| Value | Count | Frequency (%) |
| 377404.16 | 1 | |
| 377209.84 | 1 | |
| 376819.25 | 1 | |
| 376488.34 | 1 | |
| 376488.22 | 1 | |
| 251907.14 | 1 | |
| 251323.1 | 1 | |
| 250992.33 | 1 | |
| 250992.23 | 1 | |
| 250992.16 | 1 |
Block Position
Real number (ℝ)
High correlation Missing
| Distinct | 322815 |
|---|---|
| Distinct (%) | 54.1% |
| Missing | 11827 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.968921 |
| Minimum | -1511.2948 |
|---|---|
| Maximum | 116.24767 |
| Zeros | 269 |
| Zeros (%) | < 0.1% |
| Negative | 39018 |
| Negative (%) | 6.4% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -1511.2948 |
|---|---|
| 5-th percentile | -0.7169 |
| Q1 | 13.45396 |
| median | 43.59582 |
| Q3 | 79.778398 |
| 95-th percentile | 103.09833 |
| Maximum | 116.24767 |
| Range | 1627.5425 |
| Interquartile range (IQR) | 66.324438 |
Descriptive statistics
| Standard deviation | 66.410902 |
|---|---|
| Coefficient of variation (CV) | 1.4768178 |
| Kurtosis | 370.06903 |
| Mean | 44.968921 |
| Median Absolute Deviation (MAD) | 31.67784 |
| Skewness | -16.180356 |
| Sum | 26839700 |
| Variance | 4410.4079 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20.984 | 2548 | 0.4% |
| 21.76608 | 2178 | 0.4% |
| 49.24219 | 1646 | 0.3% |
| 27.30117 | 1619 | 0.3% |
| 27.30118 | 1592 | 0.3% |
| 21.76609 | 1579 | 0.3% |
| 20.98396 | 1497 | 0.2% |
| 23.39897 | 1310 | 0.2% |
| 71.46714 | 1305 | 0.2% |
| -8.80329 | 1270 | 0.2% |
| Other values (322805) | 580306 | |
| (Missing) | 11827 | 1.9% |
| Value | Count | Frequency (%) |
| -1511.2948 | 38 | |
| -1511.2946 | 6 | < 0.1% |
| -1510.4017 | 1 | < 0.1% |
| -1510.1407 | 11 | < 0.1% |
| -1509.8583 | 7 | < 0.1% |
| -1509.7875 | 1 | < 0.1% |
| -1509.7874 | 55 | |
| -1509.7587 | 1 | < 0.1% |
| -1509.5836 | 1 | < 0.1% |
| -1509.4808 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 116.24767 | 1 | < 0.1% |
| 114.75745 | 1 | < 0.1% |
| 114.52909 | 1 | < 0.1% |
| 114.4008 | 1 | < 0.1% |
| 114.40005 | 1 | < 0.1% |
| 114.35046 | 3 | < 0.1% |
| 114.35045 | 9 | |
| 114.35044 | 7 | |
| 114.35043 | 11 | |
| 114.30823 | 1 | < 0.1% |
Depth Hole Total Vertical Depth
Real number (ℝ)
High correlation Missing
| Distinct | 101805 |
|---|---|
| Distinct (%) | 17.0% |
| Missing | 11251 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7085.0323 |
| Minimum | 2 × 10-5 |
|---|---|
| Maximum | 735423 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 2 × 10-5 |
|---|---|
| 5-th percentile | 35.09238 |
| Q1 | 5123.895 |
| median | 7389.89 |
| Q3 | 10737.555 |
| 95-th percentile | 10987 |
| Maximum | 735423 |
| Range | 735423 |
| Interquartile range (IQR) | 5613.6605 |
Descriptive statistics
| Standard deviation | 3416.7931 |
|---|---|
| Coefficient of variation (CV) | 0.48225512 |
| Kurtosis | 3455.0715 |
| Mean | 7085.0323 |
| Median Absolute Deviation (MAD) | 2358.052 |
| Skewness | 15.758963 |
| Sum | 4.2327825 × 109 |
| Variance | 11674475 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10987 | 82712 | 13.6% |
| 1629.0634 | 33237 | 5.5% |
| 10955 | 25284 | 4.2% |
| 9747.942 | 22514 | 3.7% |
| 7389.89 | 16512 | 2.7% |
| 5123.895 | 14824 | 2.4% |
| 19.5118 | 14798 | 2.4% |
| 5504.8726 | 13086 | 2.1% |
| 7389 | 12697 | 2.1% |
| 8535.371 | 12280 | 2.0% |
| Other values (101795) | 349482 |
| Value | Count | Frequency (%) |
| 2 × 10-5 | 2 | < 0.1% |
| 4 × 10-5 | 1 | < 0.1% |
| 5 × 10-5 | 1 | < 0.1% |
| 6 × 10-5 | 2 | < 0.1% |
| 8 × 10-5 | 6 | |
| 0.0001 | 6 | |
| 0.00011 | 8 | |
| 0.00012 | 1 | < 0.1% |
| 0.00013 | 3 | < 0.1% |
| 0.00014 | 14 |
| Value | Count | Frequency (%) |
| 735423 | 1 | < 0.1% |
| 11146.218 | 8 | < 0.1% |
| 11146.208 | 1 | < 0.1% |
| 11144.107 | 54 | < 0.1% |
| 11135.924 | 1 | < 0.1% |
| 11114.503 | 2197 | |
| 11112.5625 | 1 | < 0.1% |
| 11108.576 | 1 | < 0.1% |
| 11106.996 | 1 | < 0.1% |
| 11104.497 | 1 | < 0.1% |
Differential Pressure
Real number (ℝ)
High correlation Missing
| Distinct | 541883 |
|---|---|
| Distinct (%) | 90.8% |
| Missing | 11814 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -681.1211 |
| Minimum | -4751.7217 |
|---|---|
| Maximum | 8598.29 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 393084 |
| Negative (%) | 64.6% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -4751.7217 |
|---|---|
| 5-th percentile | -3270.2416 |
| Q1 | -1828.7427 |
| median | -524.9963 |
| Q3 | 41.20937 |
| 95-th percentile | 319.66396 |
| Maximum | 8598.29 |
| Range | 13350.012 |
| Interquartile range (IQR) | 1869.9521 |
Descriptive statistics
| Standard deviation | 2015.1309 |
|---|---|
| Coefficient of variation (CV) | -2.9585501 |
| Kurtosis | 10.611793 |
| Mean | -681.1211 |
| Median Absolute Deviation (MAD) | 702.99458 |
| Skewness | 2.5035474 |
| Sum | -4.0653598 × 108 |
| Variance | 4060752.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8598.29 | 10990 | 1.8% |
| 8591.511 | 6329 | 1.0% |
| -4751.127 | 33 | < 0.1% |
| -4751.141 | 27 | < 0.1% |
| -4751.128 | 26 | < 0.1% |
| -4751.104 | 26 | < 0.1% |
| -4751.1133 | 26 | < 0.1% |
| -4751.1313 | 26 | < 0.1% |
| -4751.131 | 26 | < 0.1% |
| -4751.117 | 25 | < 0.1% |
| Other values (541873) | 579329 | |
| (Missing) | 11814 | 1.9% |
| Value | Count | Frequency (%) |
| -4751.7217 | 1 | |
| -4751.5625 | 1 | |
| -4751.5103 | 1 | |
| -4751.5063 | 1 | |
| -4751.4814 | 1 | |
| -4751.4688 | 1 | |
| -4751.4478 | 1 | |
| -4751.437 | 1 | |
| -4751.423 | 1 | |
| -4751.4097 | 1 |
| Value | Count | Frequency (%) |
| 8598.29 | 10990 | |
| 8598.289 | 2 | < 0.1% |
| 8598.285 | 1 | < 0.1% |
| 8598.281 | 1 | < 0.1% |
| 8598.28 | 1 | < 0.1% |
| 8598.242 | 1 | < 0.1% |
| 8598.179 | 1 | < 0.1% |
| 8598.17 | 1 | < 0.1% |
| 8597.712 | 1 | < 0.1% |
| 8597.094 | 1 | < 0.1% |
Downhole Torque
Real number (ℝ)
High correlation Missing
| Distinct | 462309 |
|---|---|
| Distinct (%) | 91.6% |
| Missing | 103996 |
| Missing (%) | 17.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5727.8502 |
| Minimum | -123044.59 |
|---|---|
| Maximum | 222650.45 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 333063 |
| Negative (%) | 54.7% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -123044.59 |
|---|---|
| 5-th percentile | -56281.266 |
| Q1 | -22020.047 |
| median | -7433.422 |
| Q3 | 578.8529 |
| 95-th percentile | 6498.125 |
| Maximum | 222650.45 |
| Range | 345695.04 |
| Interquartile range (IQR) | 22598.9 |
Descriptive statistics
| Standard deviation | 47760.968 |
|---|---|
| Coefficient of variation (CV) | -8.338376 |
| Kurtosis | 15.549084 |
| Mean | -5727.8502 |
| Median Absolute Deviation (MAD) | 9798.9845 |
| Skewness | 3.4589724 |
| Sum | -2.8907371 × 109 |
| Variance | 2.2811101 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 222650.45 | 10990 | 1.8% |
| 222474.9 | 6329 | 1.0% |
| -123031.05 | 20 | < 0.1% |
| -123029.03 | 19 | < 0.1% |
| -123029.22 | 19 | < 0.1% |
| -123029.58 | 19 | < 0.1% |
| -123031.305 | 18 | < 0.1% |
| -123028.98 | 18 | < 0.1% |
| -123029.55 | 18 | < 0.1% |
| -123029.28 | 17 | < 0.1% |
| Other values (462299) | 487214 | |
| (Missing) | 103996 | 17.1% |
| Value | Count | Frequency (%) |
| -123044.586 | 1 | |
| -123040.47 | 1 | |
| -123039.1 | 1 | |
| -123039.01 | 1 | |
| -123038.36 | 1 | |
| -123038.03 | 1 | |
| -123037.49 | 1 | |
| -123037.22 | 1 | |
| -123036.84 | 1 | |
| -123036.51 | 1 |
| Value | Count | Frequency (%) |
| 222650.45 | 10990 | |
| 222650.44 | 1 | < 0.1% |
| 222650.42 | 1 | < 0.1% |
| 222650.34 | 1 | < 0.1% |
| 222650.22 | 1 | < 0.1% |
| 222650.17 | 1 | < 0.1% |
| 222649.23 | 1 | < 0.1% |
| 222647.36 | 1 | < 0.1% |
| 222647.2 | 1 | < 0.1% |
| 222635.48 | 1 | < 0.1% |
Flow In
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 41113 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 1175 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 378.24392 |
| Minimum | 0 |
|---|---|
| Maximum | 132667.2 |
| Zeros | 284244 |
| Zeros (%) | 46.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 53.98838 |
| Q3 | 563.39465 |
| 95-th percentile | 750.19934 |
| Maximum | 132667.2 |
| Range | 132667.2 |
| Interquartile range (IQR) | 563.39465 |
Descriptive statistics
| Standard deviation | 3538.1815 |
|---|---|
| Coefficient of variation (CV) | 9.3542323 |
| Kurtosis | 1080.22 |
| Mean | 378.24392 |
| Median Absolute Deviation (MAD) | 53.98838 |
| Skewness | 32.001493 |
| Sum | 2.2978394 × 108 |
| Variance | 12518728 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 284244 | |
| 352.51685 | 542 | 0.1% |
| 352.02243 | 471 | 0.1% |
| 347.15353 | 434 | 0.1% |
| 348.6 | 428 | 0.1% |
| 348.11652 | 401 | 0.1% |
| 274.00873 | 401 | 0.1% |
| 273.70993 | 386 | 0.1% |
| 236.56174 | 370 | 0.1% |
| 347.63434 | 366 | 0.1% |
| Other values (41103) | 319459 | |
| (Missing) | 1175 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 284244 | |
| 5.67734 | 3 | < 0.1% |
| 7.73926 | 7 | < 0.1% |
| 8.6534 | 1 | < 0.1% |
| 8.67194 | 1 | < 0.1% |
| 10.1781 | 2 | < 0.1% |
| 10.59709 | 7 | < 0.1% |
| 10.63616 | 5 | < 0.1% |
| 11.08671 | 1 | < 0.1% |
| 11.0921 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 132667.2 | 1 | < 0.1% |
| 125947.42 | 1 | < 0.1% |
| 125932.51 | 1 | < 0.1% |
| 125922.13 | 1 | < 0.1% |
| 125901.48 | 4 | |
| 125900.83 | 1 | < 0.1% |
| 125896.945 | 1 | < 0.1% |
| 125896.305 | 2 | |
| 125895.67 | 2 | |
| 125895.03 | 3 |
Gamma Measured while Drilling
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 524744 |
| Missing (%) | 86.2% |
| Memory size | 32.2 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 83933 | 13.8% |
| (Missing) | 524744 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 83933 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 167866 | |
| . | 83933 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 251799 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 167866 | |
| . | 83933 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 251799 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 167866 | |
| . | 83933 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 251799 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 167866 | |
| . | 83933 |
H2S 01
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 311427 |
| Missing (%) | 51.2% |
| Memory size | 31.4 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 297250 | |
| (Missing) | 311427 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 297250 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 594500 | |
| . | 297250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 891750 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 594500 | |
| . | 297250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 891750 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 594500 | |
| . | 297250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 891750 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 594500 | |
| . | 297250 |
Hookload
Real number (ℝ)
High correlation Missing Skewed
| Distinct | 13491 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 11837 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 124.8516 |
| Minimum | 0 |
|---|---|
| Maximum | 15468.208 |
| Zeros | 4472 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36.7632 |
| Q1 | 41.62508 |
| median | 123.8774 |
| Q3 | 197.84518 |
| 95-th percentile | 255.59076 |
| Maximum | 15468.208 |
| Range | 15468.208 |
| Interquartile range (IQR) | 156.2201 |
Descriptive statistics
| Standard deviation | 115.09885 |
|---|---|
| Coefficient of variation (CV) | 0.92188525 |
| Kurtosis | 3790.4917 |
| Mean | 124.8516 |
| Median Absolute Deviation (MAD) | 81.82584 |
| Skewness | 37.111378 |
| Sum | 74516429 |
| Variance | 13247.745 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4472 | 0.7% |
| 40.55888 | 1521 | 0.2% |
| 40.81477 | 1512 | 0.2% |
| 40.68682 | 1508 | 0.2% |
| 40.77212 | 1501 | 0.2% |
| 41.07066 | 1495 | 0.2% |
| 41.11331 | 1495 | 0.2% |
| 40.64418 | 1491 | 0.2% |
| 40.60153 | 1487 | 0.2% |
| 40.98536 | 1467 | 0.2% |
| Other values (13481) | 578891 | |
| (Missing) | 11837 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 4472 | |
| 0.00051 | 15 | < 0.1% |
| 0.04316 | 13 | < 0.1% |
| 0.0858 | 14 | < 0.1% |
| 0.12845 | 14 | < 0.1% |
| 0.14593 | 1 | < 0.1% |
| 0.1711 | 10 | < 0.1% |
| 0.21375 | 9 | < 0.1% |
| 0.2564 | 7 | < 0.1% |
| 0.29905 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 15468.208 | 1 | |
| 14651.879 | 1 | |
| 14175.687 | 1 | |
| 14083.649 | 1 | |
| 13747.515 | 1 | |
| 13583.448 | 1 | |
| 12471 | 2 | |
| 12466.998 | 1 | |
| 11522.618 | 1 | |
| 9933.978 | 2 |
Inclination
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 286 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 52957 |
| Missing (%) | 8.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.457116 |
| Minimum | 0 |
|---|---|
| Maximum | 169.27 |
| Zeros | 146253 |
| Zeros (%) | 24.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1.93 |
| Q3 | 65.4 |
| 95-th percentile | 68.6 |
| Maximum | 169.27 |
| Range | 169.27 |
| Interquartile range (IQR) | 65.4 |
Descriptive statistics
| Standard deviation | 31.541369 |
|---|---|
| Coefficient of variation (CV) | 1.1921696 |
| Kurtosis | -1.3275795 |
| Mean | 26.457116 |
| Median Absolute Deviation (MAD) | 1.93 |
| Skewness | 0.57094855 |
| Sum | 14702748 |
| Variance | 994.85794 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 146253 | |
| 68.6 | 89168 | |
| 1.93 | 40680 | 6.7% |
| 1.32 | 29843 | 4.9% |
| 65.5 | 23441 | 3.9% |
| 58.13 | 20527 | 3.4% |
| 1.89 | 17491 | 2.9% |
| 1.14 | 16053 | 2.6% |
| 18.16 | 10335 | 1.7% |
| 61 | 9874 | 1.6% |
| Other values (276) | 152055 | |
| (Missing) | 52957 | 8.7% |
| Value | Count | Frequency (%) |
| 0 | 146253 | |
| 0.21 | 57 | < 0.1% |
| 0.48 | 358 | 0.1% |
| 0.53 | 318 | 0.1% |
| 0.66 | 580 | 0.1% |
| 0.7 | 5299 | 0.9% |
| 0.75 | 878 | 0.1% |
| 0.79 | 1327 | 0.2% |
| 0.84 | 1508 | 0.2% |
| 0.88 | 640 | 0.1% |
| Value | Count | Frequency (%) |
| 169.27 | 6 | < 0.1% |
| 134.15 | 5 | < 0.1% |
| 125.03 | 2929 | |
| 99.82 | 26 | < 0.1% |
| 91.38 | 326 | 0.1% |
| 87.69 | 5 | < 0.1% |
| 83.17 | 119 | < 0.1% |
| 81.87 | 95 | < 0.1% |
| 78.95 | 5 | < 0.1% |
| 70.4 | 1375 |
Mud Temperature
Real number (ℝ)
High correlation Missing
| Distinct | 3022 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 11173 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 86.74595 |
| Minimum | 0 |
|---|---|
| Maximum | 299.5 |
| Zeros | 2281 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30.1 |
| Q1 | 45.7 |
| median | 80.25 |
| Q3 | 125.5 |
| 95-th percentile | 155.7 |
| Maximum | 299.5 |
| Range | 299.5 |
| Interquartile range (IQR) | 79.8 |
Descriptive statistics
| Standard deviation | 43.757211 |
|---|---|
| Coefficient of variation (CV) | 0.50442944 |
| Kurtosis | -1.3511559 |
| Mean | 86.74595 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 0.20995893 |
| Sum | 51831052 |
| Variance | 1914.6935 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2281 | 0.4% |
| 51.6 | 1216 | 0.2% |
| 36.1 | 1125 | 0.2% |
| 42.8 | 1122 | 0.2% |
| 36.95 | 1086 | 0.2% |
| 31.45 | 1064 | 0.2% |
| 43.25 | 1027 | 0.2% |
| 35.4 | 1014 | 0.2% |
| 39.95 | 994 | 0.2% |
| 43.9 | 993 | 0.2% |
| Other values (3012) | 585582 | |
| (Missing) | 11173 | 1.8% |
| Value | Count | Frequency (%) |
| 0 | 2281 | |
| 10.25 | 3 | < 0.1% |
| 10.4 | 37 | < 0.1% |
| 10.45 | 7 | < 0.1% |
| 10.7 | 33 | < 0.1% |
| 10.85 | 19 | < 0.1% |
| 11.1 | 1 | < 0.1% |
| 11.15 | 12 | < 0.1% |
| 11.3 | 18 | < 0.1% |
| 11.55 | 30 | < 0.1% |
| Value | Count | Frequency (%) |
| 299.5 | 1 | < 0.1% |
| 173.1 | 2 | < 0.1% |
| 172.95 | 9 | |
| 172.9 | 1 | < 0.1% |
| 172.7 | 3 | < 0.1% |
| 172.65 | 2 | < 0.1% |
| 172.5 | 4 | |
| 172.25 | 7 | |
| 172.1 | 2 | < 0.1% |
| 172.05 | 2 | < 0.1% |
On Bottom
Categorical
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 11813 |
| Missing (%) | 1.9% |
| Memory size | 30.2 MiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 479400 | |
| 1.0 | 117464 | 19.3% |
| (Missing) | 11813 | 1.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 479400 | |
| 1.0 | 117464 | 19.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1076264 | |
| . | 596864 | |
| 1 | 117464 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1790592 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076264 | |
| . | 596864 | |
| 1 | 117464 | 6.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1790592 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076264 | |
| . | 596864 | |
| 1 | 117464 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1790592 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076264 | |
| . | 596864 | |
| 1 | 117464 | 6.6% |
Pump Pressure
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 243439 |
|---|---|
| Distinct (%) | 40.8% |
| Missing | 11811 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1162.5878 |
| Minimum | 0 |
|---|---|
| Maximum | 10860.391 |
| Zeros | 95931 |
| Zeros (%) | 15.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.35185 |
| median | 40.267315 |
| Q3 | 2179.2949 |
| 95-th percentile | 3731.4418 |
| Maximum | 10860.391 |
| Range | 10860.391 |
| Interquartile range (IQR) | 2173.9431 |
Descriptive statistics
| Standard deviation | 2080.9374 |
|---|---|
| Coefficient of variation (CV) | 1.7899184 |
| Kurtosis | 10.960699 |
| Mean | 1162.5878 |
| Median Absolute Deviation (MAD) | 40.267315 |
| Skewness | 3.0221215 |
| Sum | 6.9390913 × 108 |
| Variance | 4330300.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 95931 | 15.8% |
| 10860.391 | 11015 | 1.8% |
| 10853.611 | 6343 | 1.0% |
| 6.69065 | 71 | < 0.1% |
| 5.67797 | 68 | < 0.1% |
| 6.35472 | 68 | < 0.1% |
| 5.16795 | 67 | < 0.1% |
| 6.98979 | 67 | < 0.1% |
| 6.60483 | 67 | < 0.1% |
| 7.07561 | 66 | < 0.1% |
| Other values (243429) | 483103 | |
| (Missing) | 11811 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 95931 | |
| 0.00155 | 4 | < 0.1% |
| 0.004 | 6 | < 0.1% |
| 0.00645 | 10 | < 0.1% |
| 0.00762 | 1 | < 0.1% |
| 0.00891 | 7 | < 0.1% |
| 0.01136 | 9 | < 0.1% |
| 0.01172 | 1 | < 0.1% |
| 0.01381 | 7 | < 0.1% |
| 0.01626 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 10860.391 | 11015 | |
| 10853.611 | 6343 | |
| 5329.184 | 1 | < 0.1% |
| 4898.7163 | 1 | < 0.1% |
| 4895.535 | 1 | < 0.1% |
| 4747.99 | 1 | < 0.1% |
| 4677.556 | 1 | < 0.1% |
| 4659.382 | 1 | < 0.1% |
| 4651.6455 | 1 | < 0.1% |
| 4651.334 | 1 | < 0.1% |
Rate of Penetration (Depth/Hour)
Real number (ℝ)
Missing Skewed Zeros
| Distinct | 43155 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 11813 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.258759 |
| Minimum | 0 |
|---|---|
| Maximum | 147628.9 |
| Zeros | 526321 |
| Zeros (%) | 86.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 42.721367 |
| Maximum | 147628.9 |
| Range | 147628.9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 445.27147 |
|---|---|
| Coefficient of variation (CV) | 39.548894 |
| Kurtosis | 54131.09 |
| Mean | 11.258759 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 200.74346 |
| Sum | 6719947.9 |
| Variance | 198266.68 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 526321 | |
| 24.35408 | 101 | < 0.1% |
| 5.98836 | 22 | < 0.1% |
| 43.11266 | 17 | < 0.1% |
| 4.49045 | 15 | < 0.1% |
| 12.9483 | 14 | < 0.1% |
| 12.03083 | 14 | < 0.1% |
| 1.55663 | 13 | < 0.1% |
| 18.52161 | 10 | < 0.1% |
| 11.81958 | 10 | < 0.1% |
| Other values (43145) | 70327 | 11.6% |
| (Missing) | 11813 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 526321 | |
| 1 × 10-5 | 7 | < 0.1% |
| 3 × 10-5 | 1 | < 0.1% |
| 6 × 10-5 | 2 | < 0.1% |
| 8 × 10-5 | 7 | < 0.1% |
| 0.00014 | 1 | < 0.1% |
| 0.00017 | 2 | < 0.1% |
| 0.00019 | 1 | < 0.1% |
| 0.00021 | 3 | < 0.1% |
| 0.00023 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 147628.9 | 1 | |
| 133344.42 | 1 | |
| 131441.16 | 1 | |
| 97313.26 | 1 | |
| 84171.836 | 1 | |
| 51716.51 | 1 | |
| 48925.246 | 1 | |
| 48589.5 | 1 | |
| 40989.59 | 1 | |
| 35501.062 | 1 |
Return Flow
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 24834 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 11816 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.489147 |
| Minimum | 0 |
|---|---|
| Maximum | 100.0496 |
| Zeros | 58396 |
| Zeros (%) | 9.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2.22641 |
| median | 31.99345 |
| Q3 | 57.50668 |
| 95-th percentile | 75.14337 |
| Maximum | 100.0496 |
| Range | 100.0496 |
| Interquartile range (IQR) | 55.28027 |
Descriptive statistics
| Standard deviation | 27.651717 |
|---|---|
| Coefficient of variation (CV) | 0.90693641 |
| Kurtosis | -1.6497229 |
| Mean | 30.489147 |
| Median Absolute Deviation (MAD) | 28.12429 |
| Skewness | 0.15383439 |
| Sum | 18197783 |
| Variance | 764.61747 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 58396 | 9.6% |
| 2.15897 | 932 | 0.2% |
| 2.1397 | 919 | 0.2% |
| 2.1686 | 887 | 0.1% |
| 2.15415 | 868 | 0.1% |
| 2.14452 | 862 | 0.1% |
| 2.16379 | 852 | 0.1% |
| 2.14933 | 846 | 0.1% |
| 2.17342 | 835 | 0.1% |
| 2.13488 | 811 | 0.1% |
| Other values (24824) | 530653 | |
| (Missing) | 11816 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 58396 | |
| 0.00075 | 116 | < 0.1% |
| 0.00127 | 11 | < 0.1% |
| 0.00557 | 98 | < 0.1% |
| 0.00594 | 11 | < 0.1% |
| 0.00687 | 1 | < 0.1% |
| 0.01039 | 97 | < 0.1% |
| 0.0106 | 21 | < 0.1% |
| 0.0152 | 78 | < 0.1% |
| 0.01526 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 100.0496 | 1 | < 0.1% |
| 100.03996 | 1 | < 0.1% |
| 99.99661 | 3 | |
| 99.9677 | 1 | < 0.1% |
| 99.95325 | 1 | < 0.1% |
| 99.94843 | 1 | < 0.1% |
| 99.94362 | 1 | < 0.1% |
| 99.93398 | 1 | < 0.1% |
| 99.92916 | 2 | |
| 99.91471 | 1 | < 0.1% |
Rig Mode
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 87404 |
| Missing (%) | 14.4% |
| Memory size | 30.7 MiB |
| 3.0 | |
|---|---|
| 2.0 | |
| 1.0 | |
| 999.0 |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.3893008 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 3.0 | 166518 | |
| 2.0 | 149314 | |
| 1.0 | 103975 | |
| 999.0 | 101466 | |
| (Missing) | 87404 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3.0 | 166518 | |
| 2.0 | 149314 | |
| 1.0 | 103975 | |
| 999.0 | 101466 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 521273 | |
| 0 | 521273 | |
| 9 | 304398 | |
| 3 | 166518 | 9.4% |
| 2 | 149314 | 8.5% |
| 1 | 103975 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1766751 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 521273 | |
| 0 | 521273 | |
| 9 | 304398 | |
| 3 | 166518 | 9.4% |
| 2 | 149314 | 8.5% |
| 1 | 103975 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1766751 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 521273 | |
| 0 | 521273 | |
| 9 | 304398 | |
| 3 | 166518 | 9.4% |
| 2 | 149314 | 8.5% |
| 1 | 103975 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1766751 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 521273 | |
| 0 | 521273 | |
| 9 | 304398 | |
| 3 | 166518 | 9.4% |
| 2 | 149314 | 8.5% |
| 1 | 103975 | 5.9% |
Top Drive Revolutions per Minute
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 6519 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 11816 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.726232 |
| Minimum | 0 |
|---|---|
| Maximum | 227.71463 |
| Zeros | 20125 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.03004 |
| Q1 | 0.18942 |
| median | 0.31182 |
| Q3 | 24.9064 |
| 95-th percentile | 69.00357 |
| Maximum | 227.71463 |
| Range | 227.71463 |
| Interquartile range (IQR) | 24.71698 |
Descriptive statistics
| Standard deviation | 24.99593 |
|---|---|
| Coefficient of variation (CV) | 1.6973745 |
| Kurtosis | 1.9930934 |
| Mean | 14.726232 |
| Median Absolute Deviation (MAD) | 0.18114 |
| Skewness | 1.6593697 |
| Sum | 8789513.3 |
| Variance | 624.79653 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.19106 | 20280 | 3.3% |
| 0 | 20125 | 3.3% |
| 0.21118 | 20053 | 3.3% |
| 0.17093 | 19852 | 3.3% |
| 0.23131 | 19783 | 3.3% |
| 0.25144 | 19457 | 3.2% |
| 0.1508 | 18859 | 3.1% |
| 0.27156 | 18715 | 3.1% |
| 0.29169 | 17564 | 2.9% |
| 0.13068 | 17305 | 2.8% |
| Other values (6509) | 404868 |
| Value | Count | Frequency (%) |
| 0 | 20125 | |
| 0.00824 | 174 | < 0.1% |
| 0.00992 | 5359 | 0.9% |
| 0.02837 | 189 | < 0.1% |
| 0.03004 | 7266 | 1.2% |
| 0.0485 | 260 | < 0.1% |
| 0.05017 | 9209 | |
| 0.06863 | 411 | 0.1% |
| 0.0703 | 11436 | |
| 0.08877 | 750 | 0.1% |
| Value | Count | Frequency (%) |
| 227.71463 | 1 | |
| 209.57623 | 1 | |
| 148.02022 | 1 | |
| 144.1894 | 1 | |
| 144.14914 | 1 | |
| 143.26337 | 1 | |
| 142.25679 | 1 | |
| 140.25139 | 1 | |
| 139.30545 | 1 | |
| 137.28433 | 1 |
Top Drive Torque
Real number (ℝ)
High correlation Missing Zeros
| Distinct | 12339 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 11816 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1612.5876 |
| Minimum | 0 |
|---|---|
| Maximum | 31021.443 |
| Zeros | 405112 |
| Zeros (%) | 66.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2169.3882 |
| 95-th percentile | 9120.69 |
| Maximum | 31021.443 |
| Range | 31021.443 |
| Interquartile range (IQR) | 2169.3882 |
Descriptive statistics
| Standard deviation | 3171.31 |
|---|---|
| Coefficient of variation (CV) | 1.9665971 |
| Kurtosis | 5.4098575 |
| Mean | 1612.5876 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.3459377 |
| Sum | 9.6249063 × 108 |
| Variance | 10057207 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 405112 | |
| 0.77642 | 550 | 0.1% |
| 2.80127 | 426 | 0.1% |
| 4.82612 | 273 | < 0.1% |
| 6.85096 | 189 | < 0.1% |
| 561.48605 | 141 | < 0.1% |
| 565.53795 | 137 | < 0.1% |
| 4167.913 | 132 | < 0.1% |
| 4169.938 | 131 | < 0.1% |
| 559.46011 | 129 | < 0.1% |
| Other values (12329) | 189641 | |
| (Missing) | 11816 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 405112 | |
| 0.29885 | 11 | < 0.1% |
| 0.77642 | 550 | 0.1% |
| 2.3248 | 6 | < 0.1% |
| 2.80127 | 426 | 0.1% |
| 4.35074 | 1 | < 0.1% |
| 4.82612 | 273 | < 0.1% |
| 6.37669 | 1 | < 0.1% |
| 6.85096 | 189 | < 0.1% |
| 8.87581 | 108 | < 0.1% |
| Value | Count | Frequency (%) |
| 31021.443 | 1 | |
| 28468.9 | 1 | |
| 26520.207 | 1 | |
| 26198.256 | 1 | |
| 26196.23 | 1 | |
| 26141.56 | 1 | |
| 26080.814 | 1 | |
| 25299.223 | 1 | |
| 24878.055 | 1 | |
| 24491.309 | 1 |
Total Strokes per Minute
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 40160 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 1175 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.483679 |
| Minimum | 0 |
|---|---|
| Maximum | 31714.285 |
| Zeros | 284244 |
| Zeros (%) | 46.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 12.90878 |
| Q3 | 134.6803 |
| 95-th percentile | 180.18018 |
| Maximum | 31714.285 |
| Range | 31714.285 |
| Interquartile range (IQR) | 134.6803 |
Descriptive statistics
| Standard deviation | 845.80987 |
|---|---|
| Coefficient of variation (CV) | 9.3476511 |
| Kurtosis | 1080.1976 |
| Mean | 90.483679 |
| Median Absolute Deviation (MAD) | 12.90878 |
| Skewness | 32.000986 |
| Sum | 54969016 |
| Variance | 715394.34 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 284244 | |
| 84.26966 | 542 | 0.1% |
| 84.15147 | 479 | 0.1% |
| 82.98755 | 434 | 0.1% |
| 83.33334 | 424 | 0.1% |
| 83.21775 | 403 | 0.1% |
| 65.50218 | 401 | 0.1% |
| 65.43076 | 386 | 0.1% |
| 56.55042 | 370 | 0.1% |
| 83.10249 | 366 | 0.1% |
| Other values (40150) | 319453 | |
| (Missing) | 1175 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 284244 | |
| 1.85008 | 7 | < 0.1% |
| 1.95906 | 3 | < 0.1% |
| 2.06861 | 1 | < 0.1% |
| 2.07304 | 1 | < 0.1% |
| 2.43309 | 2 | < 0.1% |
| 2.53325 | 7 | < 0.1% |
| 2.54259 | 5 | < 0.1% |
| 2.65029 | 1 | < 0.1% |
| 2.65158 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 31714.285 | 1 | < 0.1% |
| 30107.914 | 1 | < 0.1% |
| 30104.348 | 1 | < 0.1% |
| 30101.867 | 1 | < 0.1% |
| 30096.93 | 4 | |
| 30096.773 | 1 | < 0.1% |
| 30095.846 | 1 | < 0.1% |
| 30095.693 | 2 | |
| 30095.541 | 2 | |
| 30095.389 | 3 |
Weight on Bit
Real number (ℝ)
High correlation Missing Skewed Zeros
| Distinct | 571023 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 11813 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.997994 |
| Minimum | -15599.576 |
|---|---|
| Maximum | 837.66199 |
| Zeros | 7148 |
| Zeros (%) | 1.2% |
| Negative | 105196 |
| Negative (%) | 17.3% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -15599.576 |
|---|---|
| 5-th percentile | -42.463463 |
| Q1 | 2.177595 |
| median | 46.95764 |
| Q3 | 172.12066 |
| 95-th percentile | 202.53039 |
| Maximum | 837.66199 |
| Range | 16437.238 |
| Interquartile range (IQR) | 169.94307 |
Descriptive statistics
| Standard deviation | 115.73301 |
|---|---|
| Coefficient of variation (CV) | 1.5854273 |
| Kurtosis | 3177.3859 |
| Mean | 72.997994 |
| Median Absolute Deviation (MAD) | 51.617135 |
| Skewness | -32.405996 |
| Sum | 43569874 |
| Variance | 13394.129 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7148 | 1.2% |
| 69.53371 | 6 | < 0.1% |
| 0.03833 | 4 | < 0.1% |
| -1.17484 | 4 | < 0.1% |
| -0.31315 | 4 | < 0.1% |
| 178.30861 | 4 | < 0.1% |
| 0.31701 | 4 | < 0.1% |
| 180.24648 | 4 | < 0.1% |
| 0.39915 | 4 | < 0.1% |
| -0.20755 | 4 | < 0.1% |
| Other values (571013) | 589678 | |
| (Missing) | 11813 | 1.9% |
| Value | Count | Frequency (%) |
| -15599.576 | 1 | |
| -14182.979 | 1 | |
| -14047.853 | 1 | |
| -13166.369 | 1 | |
| -12421.052 | 1 | |
| -12376.617 | 1 | |
| -12294.487 | 1 | |
| -11126.89 | 1 | |
| -10347.741 | 1 | |
| -9895.907 | 1 |
| Value | Count | Frequency (%) |
| 837.66199 | 1 | |
| 837.65849 | 1 | |
| 837.65805 | 1 | |
| 837.65788 | 1 | |
| 837.65009 | 1 | |
| 837.5592 | 1 | |
| 836.46167 | 1 | |
| 823.06122 | 1 | |
| 728.4349 | 1 | |
| 716.9261 | 1 |
Interactions
Correlations
| Azimuth | Bit Diameter | Bit Revolutions per Minute | Block Position | Depth Hole Total Vertical Depth | Differential Pressure | Downhole Torque | Flow In | Hookload | Inclination | Mud Temperature | On Bottom | Pump Pressure | Rate of Penetration (Depth/Hour) | Return Flow | Rig Mode | Top Drive Revolutions per Minute | Top Drive Torque | Total Strokes per Minute | Weight on Bit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Azimuth | 1.000 | 0.337 | 0.157 | 0.237 | 0.025 | 0.069 | 0.058 | 0.264 | 0.187 | 0.521 | 0.375 | 0.376 | 0.401 | 0.171 | 0.234 | 0.260 | 0.156 | 0.250 | 0.263 | 0.136 |
| Bit Diameter | 0.337 | 1.000 | 0.006 | 0.055 | 0.000 | 0.156 | 0.492 | 0.028 | 1.000 | 0.308 | 0.165 | 0.283 | 0.194 | 0.004 | 0.245 | 0.295 | 0.141 | 0.199 | 0.028 | 1.000 |
| Bit Revolutions per Minute | 0.157 | 0.006 | 1.000 | -0.060 | -0.054 | 0.579 | 0.570 | 0.936 | 0.524 | 0.064 | 0.714 | 0.000 | 0.760 | 0.440 | 0.664 | 1.000 | 0.747 | 0.763 | 0.936 | -0.424 |
| Block Position | 0.237 | 0.055 | -0.060 | 1.000 | 0.105 | -0.056 | -0.045 | -0.018 | 0.027 | 0.258 | 0.111 | 0.018 | 0.104 | 0.004 | 0.014 | 1.000 | -0.001 | 0.024 | -0.018 | 0.161 |
| Depth Hole Total Vertical Depth | 0.025 | 0.000 | -0.054 | 0.105 | 1.000 | -0.212 | -0.127 | -0.008 | 0.248 | 0.538 | -0.073 | 0.000 | 0.153 | -0.152 | -0.038 | 0.001 | -0.130 | -0.074 | -0.009 | 0.055 |
| Differential Pressure | 0.069 | 0.156 | 0.579 | -0.056 | -0.212 | 1.000 | 0.983 | 0.587 | 0.239 | 0.025 | 0.471 | 0.475 | 0.611 | 0.443 | 0.387 | 0.313 | 0.489 | 0.589 | 0.587 | -0.360 |
| Downhole Torque | 0.058 | 0.492 | 0.570 | -0.045 | -0.127 | 0.983 | 1.000 | 0.603 | 0.287 | 0.073 | 0.509 | 0.310 | 0.715 | 0.414 | 0.402 | 0.229 | 0.488 | 0.576 | 0.603 | -0.338 |
| Flow In | 0.264 | 0.028 | 0.936 | -0.018 | -0.008 | 0.587 | 0.603 | 1.000 | 0.503 | 0.128 | 0.703 | 0.037 | 0.738 | 0.459 | 0.612 | 0.026 | 0.640 | 0.746 | 1.000 | -0.387 |
| Hookload | 0.187 | 1.000 | 0.524 | 0.027 | 0.248 | 0.239 | 0.287 | 0.503 | 1.000 | 0.187 | 0.498 | 0.005 | 0.505 | 0.158 | 0.432 | 1.000 | 0.372 | 0.454 | 0.503 | -0.624 |
| Inclination | 0.521 | 0.308 | 0.064 | 0.258 | 0.538 | 0.025 | 0.073 | 0.128 | 0.187 | 1.000 | 0.169 | 0.187 | 0.327 | 0.010 | 0.098 | 0.139 | 0.018 | 0.103 | 0.128 | 0.098 |
| Mud Temperature | 0.375 | 0.165 | 0.714 | 0.111 | -0.073 | 0.471 | 0.509 | 0.703 | 0.498 | 0.169 | 1.000 | 0.683 | 0.694 | 0.410 | 0.553 | 0.427 | 0.546 | 0.665 | 0.702 | -0.245 |
| On Bottom | 0.376 | 0.283 | 0.000 | 0.018 | 0.000 | 0.475 | 0.310 | 0.037 | 0.005 | 0.187 | 0.683 | 1.000 | 0.645 | 0.000 | 0.480 | 0.963 | 0.638 | 0.616 | 0.037 | 0.006 |
| Pump Pressure | 0.401 | 0.194 | 0.760 | 0.104 | 0.153 | 0.611 | 0.715 | 0.738 | 0.505 | 0.327 | 0.694 | 0.645 | 1.000 | 0.406 | 0.592 | 0.396 | 0.491 | 0.636 | 0.737 | -0.196 |
| Rate of Penetration (Depth/Hour) | 0.171 | 0.004 | 0.440 | 0.004 | -0.152 | 0.443 | 0.414 | 0.459 | 0.158 | 0.010 | 0.410 | 0.000 | 0.406 | 1.000 | 0.411 | 0.003 | 0.403 | 0.487 | 0.459 | -0.067 |
| Return Flow | 0.234 | 0.245 | 0.664 | 0.014 | -0.038 | 0.387 | 0.402 | 0.612 | 0.432 | 0.098 | 0.553 | 0.480 | 0.592 | 0.411 | 1.000 | 0.322 | 0.433 | 0.493 | 0.611 | -0.195 |
| Rig Mode | 0.260 | 0.295 | 1.000 | 1.000 | 0.001 | 0.313 | 0.229 | 0.026 | 1.000 | 0.139 | 0.427 | 0.963 | 0.396 | 0.003 | 0.322 | 1.000 | 0.362 | 0.353 | 0.026 | 1.000 |
| Top Drive Revolutions per Minute | 0.156 | 0.141 | 0.747 | -0.001 | -0.130 | 0.489 | 0.488 | 0.640 | 0.372 | 0.018 | 0.546 | 0.638 | 0.491 | 0.403 | 0.433 | 0.362 | 1.000 | 0.790 | 0.640 | -0.275 |
| Top Drive Torque | 0.250 | 0.199 | 0.763 | 0.024 | -0.074 | 0.589 | 0.576 | 0.746 | 0.454 | 0.103 | 0.665 | 0.616 | 0.636 | 0.487 | 0.493 | 0.353 | 0.790 | 1.000 | 0.746 | -0.309 |
| Total Strokes per Minute | 0.263 | 0.028 | 0.936 | -0.018 | -0.009 | 0.587 | 0.603 | 1.000 | 0.503 | 0.128 | 0.702 | 0.037 | 0.737 | 0.459 | 0.611 | 0.026 | 0.640 | 0.746 | 1.000 | -0.387 |
| Weight on Bit | 0.136 | 1.000 | -0.424 | 0.161 | 0.055 | -0.360 | -0.338 | -0.387 | -0.624 | 0.098 | -0.245 | 0.006 | -0.196 | -0.067 | -0.195 | 1.000 | -0.275 | -0.309 | -0.387 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Date | Date (Date Only) | Date (Time Only) | Azimuth | Bit Diameter | Bit Revolutions per Minute | Block Position | Depth Hole Total Vertical Depth | Differential Pressure | Downhole Torque | Flow In | Gamma Measured while Drilling | H2S 01 | Hookload | Inclination | Mud Temperature | On Bottom | Pump Pressure | Rate of Penetration (Depth/Hour) | Return Flow | Rig Mode | Top Drive Revolutions per Minute | Top Drive Torque | Total Strokes per Minute | Weight on Bit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaT | NaT | NaT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 2020-10-25 12:38:00 | 2020-10-25 | 2025-03-17 12:38:00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 2020-10-25 12:38:00 | 2020-10-25 | 2025-03-17 12:38:00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 2020-10-25 12:38:00 | 2020-10-25 | 2025-03-17 12:38:00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 2020-10-25 12:38:00 | 2020-10-25 | 2025-03-17 12:38:00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 2020-10-25 12:39:00 | 2020-10-25 | 2025-03-17 12:39:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 2020-10-25 12:39:00 | 2020-10-25 | 2025-03-17 12:39:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 2020-10-25 12:39:00 | 2020-10-25 | 2025-03-17 12:39:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN |
| 8 | 2020-10-25 12:39:00 | 2020-10-25 | 2025-03-17 12:39:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN |
| 9 | 2020-10-25 12:39:00 | 2020-10-25 | 2025-03-17 12:39:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN |
| Date | Date (Date Only) | Date (Time Only) | Azimuth | Bit Diameter | Bit Revolutions per Minute | Block Position | Depth Hole Total Vertical Depth | Differential Pressure | Downhole Torque | Flow In | Gamma Measured while Drilling | H2S 01 | Hookload | Inclination | Mud Temperature | On Bottom | Pump Pressure | Rate of Penetration (Depth/Hour) | Return Flow | Rig Mode | Top Drive Revolutions per Minute | Top Drive Torque | Total Strokes per Minute | Weight on Bit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608667 | 2021-01-05 10:59:00 | 2021-01-05 | 2025-03-17 10:59:00 | 0.0 | 8.75 | 147.79001 | 34.61750 | 10987.0 | 352.59845 | 3655.4540 | 326.56180 | NaN | 0.0 | 148.24540 | 0.0 | 80.1 | 0.0 | 2099.2695 | 0.0 | 24.54085 | 3.0 | 68.76205 | 3270.9055 | 112.35955 | 2.40370 |
| 608668 | 2021-01-05 10:59:00 | 2021-01-05 | 2025-03-17 10:59:00 | 0.0 | 8.75 | 148.10724 | 34.61750 | 10987.0 | 353.10767 | 3660.7334 | 327.78946 | NaN | 0.0 | 148.62924 | 0.0 | 80.1 | 0.0 | 2099.3555 | 0.0 | 24.55049 | 3.0 | 68.78218 | 3046.1472 | 112.78195 | 2.36366 |
| 608669 | 2021-01-05 10:59:00 | 2021-01-05 | 2025-03-17 10:59:00 | 0.0 | 8.75 | 148.11942 | 34.61749 | 10987.0 | 352.55124 | 3653.8040 | 326.56180 | NaN | 0.0 | 148.28806 | 0.0 | 80.1 | 0.0 | 2108.2317 | 0.0 | 24.61793 | 3.0 | 68.80231 | 3331.6510 | 112.35955 | 2.35216 |
| 608670 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 148.09929 | 34.61750 | 10987.0 | 352.02194 | 3649.4773 | 327.17447 | NaN | 0.0 | 148.54395 | 0.0 | 80.1 | 0.0 | 2110.3062 | 0.0 | 24.59385 | 3.0 | 68.92306 | 3102.8430 | 112.57036 | 2.33941 |
| 608671 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 147.95840 | 34.61749 | 10987.0 | 353.79070 | 3667.8147 | 327.17447 | NaN | 0.0 | 148.33070 | 0.0 | 80.1 | 0.0 | 2109.2542 | 0.0 | 24.57939 | 3.0 | 68.78218 | 3206.1104 | 112.57036 | 2.34043 |
| 608672 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 147.93828 | 34.61750 | 10987.0 | 355.49527 | 3683.7420 | 327.17447 | NaN | 0.0 | 148.07481 | 0.0 | 80.1 | 0.0 | 2114.8032 | 0.0 | 24.51677 | 3.0 | 68.86269 | 2993.5012 | 112.57036 | 2.33120 |
| 608673 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 148.24812 | 34.61749 | 10987.0 | 356.43910 | 3693.8347 | 326.56180 | NaN | 0.0 | 148.41600 | 0.0 | 80.1 | 0.0 | 2109.2493 | 0.0 | 24.54085 | 3.0 | 68.72180 | 3023.8740 | 112.35955 | 2.33572 |
| 608674 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 148.05904 | 34.61749 | 10987.0 | 355.76685 | 3688.3015 | 327.17447 | NaN | 0.0 | 148.67189 | 0.0 | 80.1 | 0.0 | 2110.4705 | 0.0 | 24.56012 | 3.0 | 68.88281 | 3222.3090 | 112.57036 | 2.33487 |
| 608675 | 2021-01-05 11:00:00 | 2021-01-05 | 2025-03-17 11:00:00 | 0.0 | 8.75 | 148.18774 | 34.61749 | 10987.0 | 356.16720 | 3692.4521 | 327.78946 | NaN | 0.0 | 148.11746 | 0.0 | 80.1 | 0.0 | 2107.6335 | 0.0 | 24.54085 | 3.0 | 68.86269 | 3169.6630 | 112.78195 | 2.35398 |
| 608676 | 2021-01-05 11:01:00 | 2021-01-05 | 2025-03-17 11:01:00 | 0.0 | 8.75 | 147.81013 | 34.61749 | 10987.0 | 355.95685 | 3690.2715 | 326.56180 | NaN | 0.0 | 148.37335 | 0.0 | 80.1 | 0.0 | 2111.8901 | 0.0 | 24.56976 | 3.0 | 68.78218 | 2959.0789 | 112.35955 | 2.35820 |
Duplicate rows
Most frequently occurring
| Date | Date (Date Only) | Date (Time Only) | Azimuth | Bit Diameter | Bit Revolutions per Minute | Block Position | Depth Hole Total Vertical Depth | Differential Pressure | Downhole Torque | Flow In | Gamma Measured while Drilling | H2S 01 | Hookload | Inclination | Mud Temperature | On Bottom | Pump Pressure | Rate of Penetration (Depth/Hour) | Return Flow | Rig Mode | Top Drive Revolutions per Minute | Top Drive Torque | Total Strokes per Minute | Weight on Bit | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 2020-10-25 19:00:00 | 2020-10-25 | 2025-03-17 19:00:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 4 | 2020-10-25 19:01:00 | 2020-10-25 | 2025-03-17 19:01:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 5 | 2020-10-25 19:02:00 | 2020-10-25 | 2025-03-17 19:02:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 6 | 2020-10-25 19:03:00 | 2020-10-25 | 2025-03-17 19:03:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 7 | 2020-10-25 19:04:00 | 2020-10-25 | 2025-03-17 19:04:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 8 | 2020-10-25 19:05:00 | 2020-10-25 | 2025-03-17 19:05:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 9 | 2020-10-25 19:06:00 | 2020-10-25 | 2025-03-17 19:06:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 10 | 2020-10-25 19:07:00 | 2020-10-25 | 2025-03-17 19:07:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 11 | 2020-10-25 19:08:00 | 2020-10-25 | 2025-03-17 19:08:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |
| 12 | 2020-10-25 19:09:00 | 2020-10-25 | 2025-03-17 19:09:00 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | 0.0 | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.0 | NaN | 6 |